Sort Registry entry

Records what columns to sort, and whether to sort in ascending or descending order. (This Registry entry is generated and maintained by the System when a Sort is defined in a module).

Usage

This Registry entry can be assigned to users and groups:

Key User Group Group
Key 1 User Group Group
Key 2 user group Default
Key 3 Table
Key 4 table
Key 5 Sort
Key 6 title
Value rules

where:

title

is a name for the Sort. It displays in the Sort box when listing all defined Sort entries available to a user.

rules

is in the format:

xcolumn;xcolumn;...

where the value for x is either + or - indicating an ascending or descending ordered sort respectively; column is the name of a back-end field.

The records will be sorted on the first column, and any records with the same value in the first column will be sorted by the second column, and so on.

Example

This entry specifies a Sort for user emu in the Parties module. The entry defines an ascending sort on the AddPhysCity field, with a secondary descending order sort on the AddPhysState field:

Key Setting
Key 1 User
Key 2 emu
Key 3 Table
Key 4 eparties
Key 5 Sort
Key 6 Address
Value +AddPhysCity;-AddPhysState